[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
Function DUPLOOK()
Action Locates possible duplicates based on user criteria
Returns
Category Metafunction
Syntax DUPLOOK([expC])
Description Searches current dbf for exact duplicates of
field(s) selected by user. User picks a field
or fields, DUPLOOK() creates an index and prepares
a possible duplicates report.
Options <expC> Character expression as additional info for
each report line printed. (report normally only
refers to record# and the fields selected )
Examples DUPLOOK("Lastname+' '+Firstname")
* whatever fields the user picks to check duplicates
* on, the LASTNAME and FIRSTNAME fields are also
* printed on the report.
Sample Output:
Record # FNAME
1 GARRY
2 GARRY
Warnings THIS FUNCTION CLOSES ANY OPEN INDEXES.
YOU WILL NEED TO RE-OPEN INDEXES ON EXIT.
Warnings Key -9 is unset on exit (F10), cursor is left ON
Found in (prg)......S_DUP.PRG
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson